create table Employees(Employee_id numeric(6),Ss_number numeric(9),First_name varchar(20),Last_name varchar(20),Type integer,Password varchar(6),Wage float(2));

load data local infile 'c:/sql/Employees.txt' into table Employees lines terminated by '\r\n';

create table Payroll(Employee_id numeric(6),Clock_in datetime,Clock_out datetime);

load data local infile 'c:/sql/Payroll.txt' into table Payroll lines terminated by '\r\n';

create table Inactive_Orders(Order_id integer,Table_id numeric(6),Employee_id numeric(6),Menu_item_id integer,Time datetime,Quantity integer);

load data local infile 'c:/sql/Inactive_Orders.txt' into table Inactive_Orders lines terminated by '\r\n';

create table Active_Orders(Order_id integer,Table_id numeric(6),Employee_id numeric(6),Menu_item_id integer, Time datetime,Quantity integer);


create table Tabletops(Table_id numeric(6),Employee_id numeric(6),Status numeric(1),Location varchar(30));

load data local infile 'c:/sql/Tabletops.txt' into table Tabletops lines terminated by '\r\n';

create table Menu_Items(Item_id integer,Item_name varchar(30),Type integer,Regular_price float(2),Special_price float(2),Special_start varchar(20),Special_end varchar(20));

load data local infile 'c:/sql/Menu_Items.txt' into table Menu_Items lines terminated by '\r\n';